AutoProc - The Stored Procedure Generator

autoproc.zip (35 kB)
AutoProc (The Stored Procedure Generator) is a (simple to use and compatible across multiple editions) set of stored procedures which generates getter and setter procedures for complex Sql Server 2000/2005/2008 (Express/Workgroup/Standard/Enterprise/Developer) tables.

DBDocumenter

DBDocumenter, an interactive tool designed to generate the SQL Server 2000/2005/2008 documentation. It supports, export of documentation to HTML(WEB) format. It helps the developer , who's design the Data Layer for the application. He/she can easily find the name of column etc...

DBScripter - Library for scripting SQL Server database objects

DBScripter.zip (29,0 MB)
This project is library that allows users to script SQL Server database objects. Library uses dynamic management views for extracting data about databases objects. This library could be used in various situations. The most interesting areas are comparing database objects and generation database documentation. For both cases examples have been prepared.

DNN Reports (Moved to GitHub)

dnnreports.zip (7,8 MB)
DNN Reports module provides a simple, flexible, view on your database, any table, any view and display results with plugin visualizers (Moved to GitHub).

ExportSQLScript - Export MS SQL 2008R2/2008/2005/2000 objects to script

Command line driven utility to export MS SQL objects to script files suitable for database creation and revision control. Uses 2008R2 Server Management Objects (SMO) which are compatible with SQL Server 2000, SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2.

eyeArchive - Database Archiving Tool for Microsoft SQL Server

eyeArchive.zip (1,7 MB)
eyeArchive is a tool that should help DBA's to archive their MS-SQL databases (2000+). Generated scripts create stored procedures (called by a single job) that will automatically move "old" records (based on custom conditions) to an archive database. It is written in C# 2.0

Index Analysis

Index Analysis allows DBAs and developers to analyze the indexes in a database to determine the use, characteristics, and statistics of the index. The project contains the query written in T-SQL and report that can be opened as a custom report in SSMS.

Mini SQL Query - Moved to GitHub

Mini SQL Query is a minimalist SQL query tool for multiple databases is now on GitHub: https://github.com/paulkohler/minisqlquery

SQL Server Backup, Integrity Check, Index and Statistics Maintenance

SQL Server Maintenance Solution for backup, integrity check, index and statistics maintenance in SQL Server 2005, 2008, 2008 R2, 2012, 2014, and 2016

Open DBDiff

OpenDBDiff.zip (54,2 MB)
A GPL2 database comparison tool for Microsoft SQL Server 2005+ that reports schema differences and creates a synchronization script.

Power Mirrors

Leverage the usefulness of SQL Server mirrors using PowerShell and SMO. Create mirrors from scratch, assign witnesses and test failovers, all from PowerShell!

PDF.NET SOD

pwmis.zip (53,3 MB)
PWMIS 数据开发框架 PWMIS Data Develop Framework Ver 4.5 开源版本 Ver 4.5 Open Source Solution includes ORM、Web/WinForm Data Control、SQL MAPPING,ORM query language:OQL

Stored Procedures Generator - Rabbit.SPGen

RabbitSPGen.zip (10,5 MB)
Rabbit.SPGen

SQL Bandwidth Meter Log Parser

Parses the log files created by the Hosts Tools SQL Bandwidth Meter application

Sea Quail SQL Writing Library

seaquail.zip (3,0 MB)
Sea Quail is a library for building SQL queries using objects in .Net. It's intended to work with any mainstream RDBMS. Add/remove tables, columns, and foreign keys, insert, update, delete, and select programmatically, without string building. It's developed in C#.

SQL Server Backup Monitoring

This application lets monitor the backups job in SQL Server.

SQL Chart Add-in for SQL Server Management Studio

sqlchart.zip (3,5 MB)
SQL Chart renders a chart from SQL data. Simply create a query that returns data in two columns. First column for X axis and second for Y.

SQL Script Executer

SQL Executer makes it easy to deploy, execute multiple scripts on SQL Server as you could do in VS 2008. In Visual Studio 2008's Database Project, one had an option to select multiple sql files and Run them on choosen DB. Visual Studio 2010, doesn't come with this functionality.

SQL Load Generator

SQL Load Generator is used to run multiple concurrent queries against SQL Server. The user can choose the number of concurrent queries to run, provide different queries, choose SQL or domain accounts, and provide application name settings. SLG was developed using C# 3.5.

SQL Load Test

This tool takes a SQL Profiler trace file and generates a unit test that replays the same sequence of database calls found in the trace file. The unit test is designed for Visual Studio Load Test. The code generated is easily modifiable so that data variation can be included.